Overview
Brought to you by YData
Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 8582 |
| Missing cells | 3364 |
| Missing cells (%) | 2.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 947.2 KiB |
| Average record size in memory | 113.0 B |
Variable types
| Text | 6 |
|---|---|
| Numeric | 6 |
| Boolean | 1 |
| DateTime | 1 |
| Categorical | 1 |
album_total_tracks is highly overall correlated with track_number | High correlation |
artist_followers is highly overall correlated with artist_popularity | High correlation |
artist_popularity is highly overall correlated with artist_followers | High correlation |
track_number is highly overall correlated with album_total_tracks | High correlation |
artist_genres has 3361 (39.2%) missing values | Missing |
track_id has unique values | Unique |
track_popularity has 503 (5.9%) zeros | Zeros |
Reproduction
| Analysis started | 2025-11-26 19:34:16.413038 |
|---|---|
| Analysis finished | 2025-11-26 19:34:21.685790 |
| Duration | 5.27 seconds |
| Software version | ydata-profiling vv4.17.0 |
| Download configuration | config.json |
Variables
track_id
Text
Unique
| Distinct | 8582 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.2 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Unique
| Unique | 8582 ? |
|---|---|
| Unique (%) | 100.0% |
Sample
| 1st row | 3EJS5LyekDim1Tf5rBFmZl |
|---|---|
| 2nd row | 1oQW6G2ZiwMuHqlPpP27DB |
| 3rd row | 7mdkjzoIYlf1rx9EtBpGmU |
| 4th row | 67rW0Zl7oB3qEpD5YWWE5w |
| 5th row | 15xptTfRBrjsppW0INUZjf |
| Value | Count | Frequency (%) |
| 3ejs5lyekdim1tf5rbfmzl | 1 | < 0.1% |
| 0xqqpq855n5rnusfbxo2ml | 1 | < 0.1% |
| 15xpttfrbrjsppw0inuzjf | 1 | < 0.1% |
| 4ccpcczyseq8vrpmk1eds0 | 1 | < 0.1% |
| 3qoq3hqxtajgel9lbnmbyp | 1 | < 0.1% |
| 1yezbdt417sfolpqzaohs2 | 1 | < 0.1% |
| 4pz949nfw5surwze0tse7i | 1 | < 0.1% |
| 0l0lgwfz7utbnrnqvsbty6 | 1 | < 0.1% |
| 5mfazwer4javdnsy0hhuyh | 1 | < 0.1% |
| 4v1sh9y2z6e8hpznoet5rc | 1 | < 0.1% |
| Other values (8572) | 8572 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 4075 | 2.2% |
| 4 | 4057 | 2.1% |
| 2 | 4047 | 2.1% |
| 5 | 3986 | 2.1% |
| 0 | 3945 | 2.1% |
| 1 | 3945 | 2.1% |
| 3 | 3928 | 2.1% |
| 7 | 3924 | 2.1% |
| r | 3063 | 1.6% |
| K | 3025 | 1.6% |
| Other values (52) | 150809 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 188804 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 6 | 4075 | 2.2% |
| 4 | 4057 | 2.1% |
| 2 | 4047 | 2.1% |
| 5 | 3986 | 2.1% |
| 0 | 3945 | 2.1% |
| 1 | 3945 | 2.1% |
| 3 | 3928 | 2.1% |
| 7 | 3924 | 2.1% |
| r | 3063 | 1.6% |
| K | 3025 | 1.6% |
| Other values (52) | 150809 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 188804 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 6 | 4075 | 2.2% |
| 4 | 4057 | 2.1% |
| 2 | 4047 | 2.1% |
| 5 | 3986 | 2.1% |
| 0 | 3945 | 2.1% |
| 1 | 3945 | 2.1% |
| 3 | 3928 | 2.1% |
| 7 | 3924 | 2.1% |
| r | 3063 | 1.6% |
| K | 3025 | 1.6% |
| Other values (52) | 150809 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 188804 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 6 | 4075 | 2.2% |
| 4 | 4057 | 2.1% |
| 2 | 4047 | 2.1% |
| 5 | 3986 | 2.1% |
| 0 | 3945 | 2.1% |
| 1 | 3945 | 2.1% |
| 3 | 3928 | 2.1% |
| 7 | 3924 | 2.1% |
| r | 3063 | 1.6% |
| K | 3025 | 1.6% |
| Other values (52) | 150809 |
track_name
Text
| Distinct | 7462 |
|---|---|
| Distinct (%) | 86.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.2 KiB |
Length
| Max length | 99 |
|---|---|
| Median length | 81 |
| Mean length | 17.032393 |
| Min length | 1 |
Unique
| Unique | 6629 ? |
|---|---|
| Unique (%) | 77.2% |
Sample
| 1st row | Trippy Mane (ft. Project Pat) |
|---|---|
| 2nd row | OMG! |
| 3rd row | Hard 2 Find |
| 4th row | Still Get Like That (ft. Project Pat & Starrah) |
| 5th row | ride me like a harley |
| Value | Count | Frequency (%) |
| the | 1036 | 3.7% |
| 938 | 3.4% | |
| feat | 638 | 2.3% |
| you | 508 | 1.8% |
| me | 396 | 1.4% |
| i | 380 | 1.4% |
| of | 333 | 1.2% |
| a | 331 | 1.2% |
| love | 311 | 1.1% |
| my | 234 | 0.8% |
| Other values (6103) | 22526 |
Most occurring characters
| Value | Count | Frequency (%) |
| 19048 | 13.0% | |
| e | 13477 | 9.2% |
| a | 8637 | 5.9% |
| o | 8467 | 5.8% |
| i | 7083 | 4.8% |
| n | 6683 | 4.6% |
| t | 6679 | 4.6% |
| r | 6508 | 4.5% |
| s | 4720 | 3.2% |
| l | 4660 | 3.2% |
| Other values (244) | 60210 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 146172 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 19048 | 13.0% | |
| e | 13477 | 9.2% |
| a | 8637 | 5.9% |
| o | 8467 | 5.8% |
| i | 7083 | 4.8% |
| n | 6683 | 4.6% |
| t | 6679 | 4.6% |
| r | 6508 | 4.5% |
| s | 4720 | 3.2% |
| l | 4660 | 3.2% |
| Other values (244) | 60210 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 146172 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 19048 | 13.0% | |
| e | 13477 | 9.2% |
| a | 8637 | 5.9% |
| o | 8467 | 5.8% |
| i | 7083 | 4.8% |
| n | 6683 | 4.6% |
| t | 6679 | 4.6% |
| r | 6508 | 4.5% |
| s | 4720 | 3.2% |
| l | 4660 | 3.2% |
| Other values (244) | 60210 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 146172 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 19048 | 13.0% | |
| e | 13477 | 9.2% |
| a | 8637 | 5.9% |
| o | 8467 | 5.8% |
| i | 7083 | 4.8% |
| n | 6683 | 4.6% |
| t | 6679 | 4.6% |
| r | 6508 | 4.5% |
| s | 4720 | 3.2% |
| l | 4660 | 3.2% |
| Other values (244) | 60210 |
track_number
Real number (ℝ)
High correlation
| Distinct | 54 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.7725472 |
| Minimum | 1 |
|---|---|
| Maximum | 102 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 4 |
| Q3 | 9 |
| 95-th percentile | 17 |
| Maximum | 102 |
| Range | 101 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 6.052792 |
|---|---|
| Coefficient of variation (CV) | 1.0485479 |
| Kurtosis | 16.507948 |
| Mean | 5.7725472 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 2.6531938 |
| Sum | 49540 |
| Variance | 36.636291 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 2708 | |
| 2 | 814 | 9.5% |
| 3 | 686 | 8.0% |
| 4 | 564 | 6.6% |
| 5 | 480 | 5.6% |
| 6 | 423 | 4.9% |
| 7 | 363 | 4.2% |
| 9 | 338 | 3.9% |
| 8 | 336 | 3.9% |
| 10 | 309 | 3.6% |
| Other values (44) | 1561 |
| Value | Count | Frequency (%) |
| 1 | 2708 | |
| 2 | 814 | 9.5% |
| 3 | 686 | 8.0% |
| 4 | 564 | 6.6% |
| 5 | 480 | 5.6% |
| 6 | 423 | 4.9% |
| 7 | 363 | 4.2% |
| 8 | 336 | 3.9% |
| 9 | 338 | 3.9% |
| 10 | 309 | 3.6% |
| Value | Count | Frequency (%) |
| 102 | 1 | < 0.1% |
| 70 | 1 | < 0.1% |
| 66 | 1 | < 0.1% |
| 57 | 1 | < 0.1% |
| 54 | 1 | < 0.1% |
| 52 | 1 | < 0.1% |
| 49 | 1 | < 0.1% |
| 47 | 2 | |
| 46 | 2 | |
| 45 | 3 |
track_popularity
Real number (ℝ)
Zeros
| Distinct | 98 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52.356211 |
| Minimum | 0 |
|---|---|
| Maximum | 99 |
| Zeros | 503 |
| Zeros (%) | 5.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 39 |
| median | 58 |
| Q3 | 71 |
| 95-th percentile | 82 |
| Maximum | 99 |
| Range | 99 |
| Interquartile range (IQR) | 32 |
Descriptive statistics
| Standard deviation | 23.816076 |
|---|---|
| Coefficient of variation (CV) | 0.4548854 |
| Kurtosis | -0.23754128 |
| Mean | 52.356211 |
| Median Absolute Deviation (MAD) | 15 |
| Skewness | -0.78484393 |
| Sum | 449321 |
| Variance | 567.20546 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 503 | 5.9% |
| 62 | 195 | 2.3% |
| 71 | 190 | 2.2% |
| 67 | 188 | 2.2% |
| 70 | 182 | 2.1% |
| 69 | 177 | 2.1% |
| 65 | 174 | 2.0% |
| 68 | 174 | 2.0% |
| 72 | 173 | 2.0% |
| 75 | 173 | 2.0% |
| Other values (88) | 6453 |
| Value | Count | Frequency (%) |
| 0 | 503 | |
| 1 | 102 | 1.2% |
| 2 | 69 | 0.8% |
| 3 | 39 | 0.5% |
| 4 | 30 | 0.3% |
| 5 | 24 | 0.3% |
| 6 | 23 | 0.3% |
| 7 | 8 | 0.1% |
| 8 | 17 | 0.2% |
| 9 | 16 | 0.2% |
| Value | Count | Frequency (%) |
| 99 | 1 | < 0.1% |
| 97 | 1 | < 0.1% |
| 95 | 2 | < 0.1% |
| 94 | 3 | < 0.1% |
| 93 | 7 | 0.1% |
| 92 | 10 | |
| 91 | 13 | |
| 90 | 10 | |
| 89 | 13 | |
| 88 | 19 |
| Value | Count | Frequency (%) |
| False | 6434 | |
| True | 2148 | 25.0% |
artist_name
Text
| Distinct | 2547 |
|---|---|
| Distinct (%) | 29.7% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 67.2 KiB |
Length
| Max length | 41 |
|---|---|
| Median length | 32 |
| Mean length | 10.522322 |
| Min length | 1 |
Unique
| Unique | 1581 ? |
|---|---|
| Unique (%) | 18.4% |
Sample
| 1st row | Diplo |
|---|---|
| 2nd row | Yelawolf |
| 3rd row | Riff Raff |
| 4th row | Diplo |
| 5th row | Rumelis |
| Value | Count | Frequency (%) |
| the | 530 | 3.4% |
| taylor | 327 | 2.1% |
| swift | 324 | 2.1% |
| weeknd | 141 | 0.9% |
| lil | 116 | 0.7% |
| lana | 99 | 0.6% |
| del | 99 | 0.6% |
| rey | 99 | 0.6% |
| ariana | 94 | 0.6% |
| grande | 94 | 0.6% |
| Other values (3438) | 13591 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 8012 | 8.9% |
| e | 7910 | 8.8% |
| 6935 | 7.7% | |
| i | 6024 | 6.7% |
| n | 5187 | 5.7% |
| r | 5166 | 5.7% |
| o | 4570 | 5.1% |
| l | 4166 | 4.6% |
| s | 3108 | 3.4% |
| t | 2872 | 3.2% |
| Other values (124) | 36321 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 90271 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 8012 | 8.9% |
| e | 7910 | 8.8% |
| 6935 | 7.7% | |
| i | 6024 | 6.7% |
| n | 5187 | 5.7% |
| r | 5166 | 5.7% |
| o | 4570 | 5.1% |
| l | 4166 | 4.6% |
| s | 3108 | 3.4% |
| t | 2872 | 3.2% |
| Other values (124) | 36321 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 90271 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 8012 | 8.9% |
| e | 7910 | 8.8% |
| 6935 | 7.7% | |
| i | 6024 | 6.7% |
| n | 5187 | 5.7% |
| r | 5166 | 5.7% |
| o | 4570 | 5.1% |
| l | 4166 | 4.6% |
| s | 3108 | 3.4% |
| t | 2872 | 3.2% |
| Other values (124) | 36321 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 90271 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 8012 | 8.9% |
| e | 7910 | 8.8% |
| 6935 | 7.7% | |
| i | 6024 | 6.7% |
| n | 5187 | 5.7% |
| r | 5166 | 5.7% |
| o | 4570 | 5.1% |
| l | 4166 | 4.6% |
| s | 3108 | 3.4% |
| t | 2872 | 3.2% |
| Other values (124) | 36321 |
artist_popularity
Real number (ℝ)
High correlation
| Distinct | 96 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 69.730016 |
| Minimum | 0 |
|---|---|
| Maximum | 100 |
| Zeros | 25 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 30 |
| Q1 | 60 |
| median | 74 |
| Q3 | 84 |
| 95-th percentile | 95 |
| Maximum | 100 |
| Range | 100 |
| Interquartile range (IQR) | 24 |
Descriptive statistics
| Standard deviation | 19.645979 |
|---|---|
| Coefficient of variation (CV) | 0.28174351 |
| Kurtosis | 1.026035 |
| Mean | 69.730016 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -1.0392656 |
| Sum | 598423 |
| Variance | 385.96451 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 88 | 428 | 5.0% |
| 81 | 365 | 4.3% |
| 85 | 328 | 3.8% |
| 100 | 324 | 3.8% |
| 83 | 279 | 3.3% |
| 82 | 239 | 2.8% |
| 84 | 229 | 2.7% |
| 90 | 223 | 2.6% |
| 76 | 215 | 2.5% |
| 78 | 209 | 2.4% |
| Other values (86) | 5743 |
| Value | Count | Frequency (%) |
| 0 | 25 | |
| 1 | 4 | < 0.1% |
| 2 | 13 | |
| 3 | 7 | 0.1% |
| 4 | 14 | |
| 5 | 8 | 0.1% |
| 6 | 8 | 0.1% |
| 7 | 8 | 0.1% |
| 8 | 18 | |
| 9 | 8 | 0.1% |
| Value | Count | Frequency (%) |
| 100 | 324 | |
| 95 | 140 | 1.6% |
| 94 | 46 | 0.5% |
| 93 | 95 | 1.1% |
| 91 | 89 | 1.0% |
| 90 | 223 | |
| 89 | 99 | 1.2% |
| 88 | 428 | |
| 87 | 71 | 0.8% |
| 86 | 142 | 1.7% |
artist_followers
Real number (ℝ)
High correlation
| Distinct | 3740 |
|---|---|
| Distinct (%) | 43.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24034719 |
| Minimum | 0 |
|---|---|
| Maximum | 1.4554214 × 108 |
| Zeros | 8 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.2 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3567.7 |
| Q1 | 462320 |
| median | 6105547 |
| Q3 | 27252551 |
| 95-th percentile | 1.1869218 × 108 |
| Maximum | 1.4554214 × 108 |
| Range | 1.4554214 × 108 |
| Interquartile range (IQR) | 26790231 |
Descriptive statistics
| Standard deviation | 38031805 |
|---|---|
| Coefficient of variation (CV) | 1.5823694 |
| Kurtosis | 2.854826 |
| Mean | 24034719 |
| Median Absolute Deviation (MAD) | 6070837 |
| Skewness | 1.9611416 |
| Sum | 2.0626596 × 1011 |
| Variance | 1.4464182 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 145396321 | 137 | 1.6% |
| 145489371 | 90 | 1.0% |
| 145443567 | 85 | 1.0% |
| 112918137 | 60 | 0.7% |
| 51773650 | 44 | 0.5% |
| 103039388 | 41 | 0.5% |
| 21591569 | 39 | 0.5% |
| 47716988 | 38 | 0.4% |
| 112995439 | 38 | 0.4% |
| 23384088 | 36 | 0.4% |
| Other values (3730) | 7974 |
| Value | Count | Frequency (%) |
| 0 | 8 | |
| 2 | 1 | < 0.1% |
| 3 | 3 | < 0.1% |
| 4 | 4 | |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 8 | 1 | < 0.1% |
| 10 | 8 | |
| 12 | 2 | < 0.1% |
| 13 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 145542136 | 12 | 0.1% |
| 145489371 | 90 | |
| 145443567 | 85 | |
| 145396321 | 137 | |
| 122802777 | 14 | 0.2% |
| 122789460 | 12 | 0.1% |
| 122773292 | 27 | 0.3% |
| 118797451 | 1 | < 0.1% |
| 118760311 | 7 | 0.1% |
| 118728633 | 17 | 0.2% |
artist_genres
Text
Missing
| Distinct | 661 |
|---|---|
| Distinct (%) | 12.7% |
| Missing | 3361 |
| Missing (%) | 39.2% |
| Memory size | 67.2 KiB |
Length
| Max length | 120 |
|---|---|
| Median length | 79 |
| Mean length | 19.568473 |
| Min length | 3 |
Unique
| Unique | 340 ? |
|---|---|
| Unique (%) | 6.5% |
Sample
| 1st row | moombahton |
|---|---|
| 2nd row | country hip hop, southern hip hop |
| 3rd row | moombahton |
| 4th row | dark r&b |
| 5th row | dark r&b |
| Value | Count | Frequency (%) |
| pop | 2496 | 15.2% |
| rock | 1099 | 6.7% |
| country | 1008 | 6.1% |
| hop | 764 | 4.7% |
| hip | 757 | 4.6% |
| rap | 666 | 4.1% |
| r&b | 626 | 3.8% |
| alternative | 584 | 3.6% |
| indie | 543 | 3.3% |
| metal | 474 | 2.9% |
| Other values (338) | 7411 |
Most occurring characters
| Value | Count | Frequency (%) |
| 11207 | 11.0% | |
| o | 9604 | 9.4% |
| p | 8988 | 8.8% |
| r | 7316 | 7.2% |
| a | 6752 | 6.6% |
| t | 6126 | 6.0% |
| e | 5775 | 5.7% |
| , | 5606 | 5.5% |
| n | 5192 | 5.1% |
| i | 4902 | 4.8% |
| Other values (26) | 30699 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 102167 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 11207 | 11.0% | |
| o | 9604 | 9.4% |
| p | 8988 | 8.8% |
| r | 7316 | 7.2% |
| a | 6752 | 6.6% |
| t | 6126 | 6.0% |
| e | 5775 | 5.7% |
| , | 5606 | 5.5% |
| n | 5192 | 5.1% |
| i | 4902 | 4.8% |
| Other values (26) | 30699 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 102167 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 11207 | 11.0% | |
| o | 9604 | 9.4% |
| p | 8988 | 8.8% |
| r | 7316 | 7.2% |
| a | 6752 | 6.6% |
| t | 6126 | 6.0% |
| e | 5775 | 5.7% |
| , | 5606 | 5.5% |
| n | 5192 | 5.1% |
| i | 4902 | 4.8% |
| Other values (26) | 30699 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 102167 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 11207 | 11.0% | |
| o | 9604 | 9.4% |
| p | 8988 | 8.8% |
| r | 7316 | 7.2% |
| a | 6752 | 6.6% |
| t | 6126 | 6.0% |
| e | 5775 | 5.7% |
| , | 5606 | 5.5% |
| n | 5192 | 5.1% |
| i | 4902 | 4.8% |
| Other values (26) | 30699 |
album_id
Text
| Distinct | 5205 |
|---|---|
| Distinct (%) | 60.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.2 KiB |
Length
| Max length | 22 |
|---|---|
| Median length | 22 |
| Mean length | 22 |
| Min length | 22 |
Unique
| Unique | 4295 ? |
|---|---|
| Unique (%) | 50.0% |
Sample
| 1st row | 5QRFnGnBeMGePBKF2xTz5z |
|---|---|
| 2nd row | 4SUmmwnv0xTjRcLdjczGg2 |
| 3rd row | 3E3zEAL8gUYWaLYB9L7gbp |
| 4th row | 5QRFnGnBeMGePBKF2xTz5z |
| 5th row | 06FDIpSHYmZAZoyuYtc7kd |
| Value | Count | Frequency (%) |
| 3ffgbuutkwn1c4f0cjr4uh | 70 | 0.8% |
| 1mpaxutvl2ej5x0jhispq8 | 46 | 0.5% |
| 5h7ixxzfsnmgbie5obspcb | 31 | 0.4% |
| 2xgeygu76kj55odhwynx0s | 27 | 0.3% |
| 4hdok0oajd57sgit8xuwjh | 26 | 0.3% |
| 1atl5glyefjaxhqzspvrlx | 25 | 0.3% |
| 43wfm1hquliy3iwkwzpn4y | 25 | 0.3% |
| 2qredhp5rmkjij1i8vgdgr | 24 | 0.3% |
| 3rqqmkqevncy4prgke6oc5 | 23 | 0.3% |
| 5voerutrghtbkelufwymwu | 23 | 0.3% |
| Other values (5195) | 8262 |
Most occurring characters
| Value | Count | Frequency (%) |
| 5 | 4279 | 2.3% |
| 6 | 4117 | 2.2% |
| 4 | 4038 | 2.1% |
| 3 | 4016 | 2.1% |
| 0 | 3963 | 2.1% |
| 1 | 3864 | 2.0% |
| 2 | 3841 | 2.0% |
| 7 | 3617 | 1.9% |
| J | 3214 | 1.7% |
| F | 3178 | 1.7% |
| Other values (52) | 150677 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 188804 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 5 | 4279 | 2.3% |
| 6 | 4117 | 2.2% |
| 4 | 4038 | 2.1% |
| 3 | 4016 | 2.1% |
| 0 | 3963 | 2.1% |
| 1 | 3864 | 2.0% |
| 2 | 3841 | 2.0% |
| 7 | 3617 | 1.9% |
| J | 3214 | 1.7% |
| F | 3178 | 1.7% |
| Other values (52) | 150677 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 188804 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 5 | 4279 | 2.3% |
| 6 | 4117 | 2.2% |
| 4 | 4038 | 2.1% |
| 3 | 4016 | 2.1% |
| 0 | 3963 | 2.1% |
| 1 | 3864 | 2.0% |
| 2 | 3841 | 2.0% |
| 7 | 3617 | 1.9% |
| J | 3214 | 1.7% |
| F | 3178 | 1.7% |
| Other values (52) | 150677 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 188804 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 5 | 4279 | 2.3% |
| 6 | 4117 | 2.2% |
| 4 | 4038 | 2.1% |
| 3 | 4016 | 2.1% |
| 0 | 3963 | 2.1% |
| 1 | 3864 | 2.0% |
| 2 | 3841 | 2.0% |
| 7 | 3617 | 1.9% |
| J | 3214 | 1.7% |
| F | 3178 | 1.7% |
| Other values (52) | 150677 |
album_name
Text
| Distinct | 4870 |
|---|---|
| Distinct (%) | 56.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.2 KiB |
Length
| Max length | 99 |
|---|---|
| Median length | 83 |
| Mean length | 20.944419 |
| Min length | 1 |
Unique
| Unique | 3824 ? |
|---|---|
| Unique (%) | 44.6% |
Sample
| 1st row | d00mscrvll, Vol. 1 |
|---|---|
| 2nd row | OMG! |
| 3rd row | Hard 2 Find |
| 4th row | d00mscrvll, Vol. 1 |
| 5th row | come closer / ride me like a harley |
| Value | Count | Frequency (%) |
| the | 1732 | 5.8% |
| deluxe | 729 | 2.4% |
| original | 564 | 1.9% |
| soundtrack | 560 | 1.9% |
| of | 541 | 1.8% |
| edition | 491 | 1.6% |
| 442 | 1.5% | |
| motion | 360 | 1.2% |
| picture | 356 | 1.2% |
| a | 302 | 1.0% |
| Other values (4788) | 23983 |
Most occurring characters
| Value | Count | Frequency (%) |
| 21464 | 11.9% | |
| e | 15663 | 8.7% |
| o | 10147 | 5.6% |
| i | 10121 | 5.6% |
| a | 9115 | 5.1% |
| n | 8819 | 4.9% |
| r | 8814 | 4.9% |
| t | 7636 | 4.2% |
| l | 6195 | 3.4% |
| s | 5781 | 3.2% |
| Other values (298) | 75990 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 179745 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 21464 | 11.9% | |
| e | 15663 | 8.7% |
| o | 10147 | 5.6% |
| i | 10121 | 5.6% |
| a | 9115 | 5.1% |
| n | 8819 | 4.9% |
| r | 8814 | 4.9% |
| t | 7636 | 4.2% |
| l | 6195 | 3.4% |
| s | 5781 | 3.2% |
| Other values (298) | 75990 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 179745 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 21464 | 11.9% | |
| e | 15663 | 8.7% |
| o | 10147 | 5.6% |
| i | 10121 | 5.6% |
| a | 9115 | 5.1% |
| n | 8819 | 4.9% |
| r | 8814 | 4.9% |
| t | 7636 | 4.2% |
| l | 6195 | 3.4% |
| s | 5781 | 3.2% |
| Other values (298) | 75990 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 179745 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 21464 | 11.9% | |
| e | 15663 | 8.7% |
| o | 10147 | 5.6% |
| i | 10121 | 5.6% |
| a | 9115 | 5.1% |
| n | 8819 | 4.9% |
| r | 8814 | 4.9% |
| t | 7636 | 4.2% |
| l | 6195 | 3.4% |
| s | 5781 | 3.2% |
| Other values (298) | 75990 |
album_release_date
Date
| Distinct | 2384 |
|---|---|
| Distinct (%) | 27.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.2 KiB |
| Minimum | 1952-09-12 00:00:00 |
|---|---|
| Maximum | 2025-10-31 00:00:00 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
Histogram with fixed size bins (bins=50)
album_total_tracks
Real number (ℝ)
High correlation
| Distinct | 82 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.789443 |
| Minimum | 1 |
|---|---|
| Maximum | 181 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.2 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 6 |
| median | 13 |
| Q3 | 17 |
| 95-th percentile | 31 |
| Maximum | 181 |
| Range | 180 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 11.887131 |
|---|---|
| Coefficient of variation (CV) | 0.86204573 |
| Kurtosis | 18.467315 |
| Mean | 13.789443 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 2.8721505 |
| Sum | 118341 |
| Variance | 141.30387 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 1627 | |
| 12 | 657 | 7.7% |
| 16 | 534 | 6.2% |
| 13 | 528 | 6.2% |
| 14 | 500 | 5.8% |
| 11 | 452 | 5.3% |
| 17 | 446 | 5.2% |
| 15 | 444 | 5.2% |
| 10 | 419 | 4.9% |
| 18 | 300 | 3.5% |
| Other values (72) | 2675 |
| Value | Count | Frequency (%) |
| 1 | 1627 | |
| 2 | 193 | 2.2% |
| 3 | 132 | 1.5% |
| 4 | 89 | 1.0% |
| 5 | 81 | 0.9% |
| 6 | 73 | 0.9% |
| 7 | 79 | 0.9% |
| 8 | 84 | 1.0% |
| 9 | 133 | 1.5% |
| 10 | 419 | 4.9% |
| Value | Count | Frequency (%) |
| 181 | 1 | < 0.1% |
| 144 | 2 | |
| 137 | 1 | < 0.1% |
| 136 | 1 | < 0.1% |
| 131 | 1 | < 0.1% |
| 100 | 4 | |
| 99 | 1 | < 0.1% |
| 92 | 2 | |
| 85 | 2 | |
| 84 | 1 | < 0.1% |
album_type
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 67.2 KiB |
| album | |
|---|---|
| single | |
| compilation | 507 |
Length
| Max length | 11 |
|---|---|
| Median length | 5 |
| Mean length | 5.6130273 |
| Min length | 5 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | album |
|---|---|
| 2nd row | single |
| 3rd row | single |
| 4th row | album |
| 5th row | single |
Common Values
| Value | Count | Frequency (%) |
| album | 5856 | |
| single | 2219 | 25.9% |
| compilation | 507 | 5.9% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| album | 5856 | |
| single | 2219 | 25.9% |
| compilation | 507 | 5.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| l | 8582 | |
| a | 6363 | |
| m | 6363 | |
| b | 5856 | |
| u | 5856 | |
| i | 3233 | 6.7% |
| n | 2726 | 5.7% |
| s | 2219 | 4.6% |
| g | 2219 | 4.6% |
| e | 2219 | 4.6% |
| Other values (4) | 2535 | 5.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 48171 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| l | 8582 | |
| a | 6363 | |
| m | 6363 | |
| b | 5856 | |
| u | 5856 | |
| i | 3233 | 6.7% |
| n | 2726 | 5.7% |
| s | 2219 | 4.6% |
| g | 2219 | 4.6% |
| e | 2219 | 4.6% |
| Other values (4) | 2535 | 5.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 48171 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| l | 8582 | |
| a | 6363 | |
| m | 6363 | |
| b | 5856 | |
| u | 5856 | |
| i | 3233 | 6.7% |
| n | 2726 | 5.7% |
| s | 2219 | 4.6% |
| g | 2219 | 4.6% |
| e | 2219 | 4.6% |
| Other values (4) | 2535 | 5.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 48171 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| l | 8582 | |
| a | 6363 | |
| m | 6363 | |
| b | 5856 | |
| u | 5856 | |
| i | 3233 | 6.7% |
| n | 2726 | 5.7% |
| s | 2219 | 4.6% |
| g | 2219 | 4.6% |
| e | 2219 | 4.6% |
| Other values (4) | 2535 | 5.3% |
track_duration_min
Real number (ℝ)
| Distinct | 647 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.4928047 |
| Minimum | 0.07 |
|---|---|
| Maximum | 13.51 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 67.2 KiB |
Quantile statistics
| Minimum | 0.07 |
|---|---|
| 5-th percentile | 1.99 |
| Q1 | 2.88 |
| median | 3.445 |
| Q3 | 3.99 |
| 95-th percentile | 5.18 |
| Maximum | 13.51 |
| Range | 13.44 |
| Interquartile range (IQR) | 1.11 |
Descriptive statistics
| Standard deviation | 1.0579697 |
|---|---|
| Coefficient of variation (CV) | 0.30289977 |
| Kurtosis | 7.0457689 |
| Mean | 3.4928047 |
| Median Absolute Deviation (MAD) | 0.555 |
| Skewness | 1.2846865 |
| Sum | 29975.25 |
| Variance | 1.1193 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.67 | 58 | 0.7% |
| 3.47 | 57 | 0.7% |
| 3.24 | 56 | 0.7% |
| 3.42 | 55 | 0.6% |
| 3.86 | 52 | 0.6% |
| 3.78 | 52 | 0.6% |
| 3.36 | 51 | 0.6% |
| 3.71 | 51 | 0.6% |
| 3.07 | 50 | 0.6% |
| 3.03 | 49 | 0.6% |
| Other values (637) | 8051 |
| Value | Count | Frequency (%) |
| 0.07 | 1 | |
| 0.14 | 1 | |
| 0.19 | 1 | |
| 0.2 | 1 | |
| 0.21 | 1 | |
| 0.22 | 1 | |
| 0.3 | 1 | |
| 0.36 | 1 | |
| 0.37 | 1 | |
| 0.43 | 1 |
| Value | Count | Frequency (%) |
| 13.51 | 1 | |
| 13.15 | 1 | |
| 12.45 | 1 | |
| 12.4 | 1 | |
| 11.53 | 1 | |
| 11.47 | 1 | |
| 10.86 | 1 | |
| 10.31 | 1 | |
| 10.21 | 1 | |
| 9.88 | 1 |
Interactions
Correlations
| album_total_tracks | album_type | artist_followers | artist_popularity | explicit | track_duration_min | track_number | track_popularity | |
|---|---|---|---|---|---|---|---|---|
| album_total_tracks | 1.000 | 0.226 | 0.299 | 0.294 | 0.097 | 0.138 | 0.629 | 0.009 |
| album_type | 0.226 | 1.000 | 0.191 | 0.263 | 0.102 | 0.175 | 0.190 | 0.164 |
| artist_followers | 0.299 | 0.191 | 1.000 | 0.953 | 0.287 | 0.303 | 0.291 | 0.419 |
| artist_popularity | 0.294 | 0.263 | 0.953 | 1.000 | 0.215 | 0.256 | 0.278 | 0.465 |
| explicit | 0.097 | 0.102 | 0.287 | 0.215 | 1.000 | 0.029 | 0.050 | 0.174 |
| track_duration_min | 0.138 | 0.175 | 0.303 | 0.256 | 0.029 | 1.000 | 0.169 | 0.144 |
| track_number | 0.629 | 0.190 | 0.291 | 0.278 | 0.050 | 0.169 | 1.000 | 0.026 |
| track_popularity | 0.009 | 0.164 | 0.419 | 0.465 | 0.174 | 0.144 | 0.026 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| track_id | track_name | track_number | track_popularity | explicit | artist_name | artist_popularity | artist_followers | artist_genres | album_id | album_name | album_release_date | album_total_tracks | album_type | track_duration_min | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 3EJS5LyekDim1Tf5rBFmZl | Trippy Mane (ft. Project Pat) | 4 | 0 | True | Diplo | 77 | 2812821 | moombahton | 5QRFnGnBeMGePBKF2xTz5z | d00mscrvll, Vol. 1 | 2025-10-31 | 9 | album | 1.55 |
| 1 | 1oQW6G2ZiwMuHqlPpP27DB | OMG! | 1 | 0 | True | Yelawolf | 64 | 2363438 | country hip hop, southern hip hop | 4SUmmwnv0xTjRcLdjczGg2 | OMG! | 2025-10-31 | 1 | single | 3.07 |
| 2 | 7mdkjzoIYlf1rx9EtBpGmU | Hard 2 Find | 1 | 4 | True | Riff Raff | 48 | 193302 | NaN | 3E3zEAL8gUYWaLYB9L7gbp | Hard 2 Find | 2025-10-31 | 1 | single | 2.55 |
| 3 | 67rW0Zl7oB3qEpD5YWWE5w | Still Get Like That (ft. Project Pat & Starrah) | 8 | 30 | True | Diplo | 77 | 2813710 | moombahton | 5QRFnGnBeMGePBKF2xTz5z | d00mscrvll, Vol. 1 | 2025-10-31 | 9 | album | 1.69 |
| 4 | 15xptTfRBrjsppW0INUZjf | ride me like a harley | 2 | 0 | True | Rumelis | 48 | 8682 | dark r&b | 06FDIpSHYmZAZoyuYtc7kd | come closer / ride me like a harley | 2025-10-30 | 2 | single | 2.39 |
| 5 | 4ccpCcZYseq8VrPMK1EDs0 | BLEED | 1 | 2 | False | Minzie | 46 | 7218 | dark r&b | 2NQv9p3ZQW0Ed1LB9enix8 | BLEED | 2025-10-30 | 3 | single | 2.76 |
| 6 | 3QoQ3HqXTAjgEl9LbNMbYp | Te Procuro na Cidade | 1 | 20 | False | AZERDK | 30 | 1657 | NaN | 1PpuOsLjPWshDLxkr0oHeU | Te Procuro na Cidade | 2025-10-30 | 1 | single | 4.12 |
| 7 | 1YEZbdT417SfolPQzaoHs2 | come closer | 1 | 27 | False | Rumelis | 49 | 8802 | dark r&b | 06FDIpSHYmZAZoyuYtc7kd | come closer / ride me like a harley | 2025-10-30 | 2 | single | 2.53 |
| 8 | 4pZ949nFW5SurwzE0TSe7I | Cupido Vagabundo | 1 | 16 | False | Toni dos Anjos | 6 | 475 | NaN | 60DLQZkzpvDvVfvEC6VOJM | Cupido Vagabundo | 2025-10-30 | 2 | single | 2.92 |
| 9 | 0L0LgwFZ7UtBnRNQvSBty6 | LET’S GO! | 1 | 33 | True | PsychoYP | 48 | 154802 | nigerian drill, alté, afro adura, afrobeats, afrobeat, afroswing | 3ARxksm8CspGeAaZZB1v2w | LET’S GO! | 2025-10-28 | 1 | single | 2.40 |
| track_id | track_name | track_number | track_popularity | explicit | artist_name | artist_popularity | artist_followers | artist_genres | album_id | album_name | album_release_date | album_total_tracks | album_type | track_duration_min | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8572 | 4fQMGlCawbTkH9yPPZ49kP | Green Onions | 1 | 69 | False | Booker T. & the M.G.'s | 54 | 339450 | NaN | 2aGFVLz0oQPa3uxCfq9lcU | Green Onions | 1962-06-30 | 12 | album | 2.93 |
| 8573 | 0Jw3cPBXlGnA6DEJrZSTI0 | Soul Bossa Nova | 1 | 56 | False | Quincy Jones | 56 | 456253 | soul jazz, big band, quiet storm | 1KSOL1jvue2lfcdsNZ7YN8 | Big Band Bossa Nova | 1962-01-01 | 10 | album | 2.77 |
| 8574 | 3OnCnEWgy79xR5pr2kv4TX | Misirlou | 4 | 47 | False | Dick Dale | 41 | 137984 | surf rock | 7bGmjO5Cthm1SNOwUhLwKE | Wanna Surf? | 1960-12-10 | 19 | album | 2.26 |
| 8575 | 2QfiRTz5Yc8DdShCxG1tB2 | Johnny B. Goode | 6 | 74 | False | Chuck Berry | 63 | 2211249 | rockabilly, rock and roll | 6eedtCtCjibu80yOhylSGL | Berry Is On Top | 1959-07-01 | 12 | album | 2.69 |
| 8576 | 68FTJoO8edSpzuYb6lGW6P | Saddle Tramp | 14 | 58 | False | Marty Robbins | 61 | 626733 | classic country, outlaw country | 3kQpBS26lAj0A0VGl1snRl | Gunfighter Ballads And Trail Songs | 1959-06-30 | 15 | album | 2.05 |
| 8577 | 0AQquaENerGps8BQmbPw14 | Big Iron | 1 | 71 | False | Marty Robbins | 60 | 626733 | classic country, outlaw country | 3kQpBS26lAj0A0VGl1snRl | Gunfighter Ballads And Trail Songs | 1959-06-30 | 15 | album | 3.92 |
| 8578 | 4f8hBeMXMvssn6HtFAtblo | El Paso | 10 | 64 | False | Marty Robbins | 61 | 626733 | classic country, outlaw country | 3kQpBS26lAj0A0VGl1snRl | Gunfighter Ballads And Trail Songs | 1959-06-30 | 15 | album | 4.32 |
| 8579 | 0Vy7wsXNFrbNc6UTWoScnM | Over the Rainbow | 5 | 8 | False | The Mystics | 27 | 18184 | doo-wop | 2ifB9Xjp9DdpqLlYlY60QW | Presenting The Mystics | 1959-02-11 | 9 | compilation | 2.28 |
| 8580 | 760clbeDBWmBsBLbszWuNZ | I'm A Man | 2 | 55 | False | Bo Diddley | 44 | 333376 | blues, classic blues, rock and roll, rockabilly | 1cbtDEwxCjMhglb49OgNBR | Bo Diddley | 1958-01-01 | 12 | album | 2.74 |
| 8581 | 61GEP8lryEfcuEgBMbRmNi | Alone And Forsaken | 11 | 45 | False | Hank Williams | 55 | 1067339 | classic country, honky tonk, traditional country, outlaw country, country, christian country | 3cusZESjkIDnDXyQwbpSsT | Moanin' The Blues (Expanded Edition) | 1952-09-12 | 12 | album | 2.02 |